{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Web form","Options","Instructions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Web form","index":0,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["JetBox Osbourne product configurator",null,"v1.1","2024-10-02",null,"Hide","Hide","Hide","Hide"]
["Click yellow cell. Then click arrow that appears to the right to choose an option.",null,null,null,null,"for","for","for","for"]
["Options with * are considered \"default\" options.",null,null,null,null,"Customer","Customer","Customer","Customer"]
["Part number and part description text will automatically fill in based on your selections.",null,null,null,null,"Use","Use","Use","Use"]
["All options must be selected to generate a valid configuration and part number."]
["Then submit this configuration worksheet to the email address below for a quote or further discussion with our technical sales team."]
["sales@diamondsystems.com"]
[null,null,null,"Part number builder text","Part description builder text","Cost","Margin","Price"]
["Base model (no selection required)",null,null,"JB-OSB","JetBox Osbourne, ",630,0.5,{"$f":"ROUND(F9/(1-G9),0)","v":1260},"Includes enclosure, OSB-BB01, and OSB-PNL01"]
[]
[{"$f":"Options!A1","v":"Orin Module"},"Choose One:",null,{"$f":"VLOOKUP(B11,Options!A:C,2,FALSE)","v":""},{"$f":"VLOOKUP(B11,Options!A:C,3,FALSE)","v":""},{"$f":"VLOOKUP(B11,Options!A:F,4,FALSE)","v":0},{"$f":"VLOOKUP(B11,Options!A:F,5,FALSE)","v":0},{"$f":"VLOOKUP(B11,Options!A:F,6,FALSE)","v":0}]
[]
[{"$f":"Options!G1","v":"Integrated mass storage"},"Choose One:",null,{"$f":"VLOOKUP(B13,Options!G:I,2,FALSE)","v":""},{"$f":"VLOOKUP(B13,Options!G:I,3,FALSE)","v":""},{"$f":"VLOOKUP(B13,Options!G:L,4,FALSE)","v":0},{"$f":"VLOOKUP(B13,Options!G:L,5,FALSE)","v":0},{"$f":"VLOOKUP(B13,Options!G:L,6,FALSE)","v":0}]
[]
[{"$f":"Options!M1","v":"GMSL Cameras"},"Choose One:",null,{"$f":"VLOOKUP(B15,Options!M:O,2,FALSE)","v":""},{"$f":"VLOOKUP(B15,Options!M:R,3,FALSE)","v":""},{"$f":"VLOOKUP(B15,Options!M:R,4,FALSE)","v":0},{"$f":"VLOOKUP(B15,Options!M:R,5,FALSE)","v":0},{"$f":"VLOOKUP(B15,Options!M:R,6,FALSE)","v":0}]
[]
[{"$f":"Options!S1","v":"Expansion I/O"},"Choose One:",null,{"$f":"VLOOKUP(B17,Options!S:U,2,FALSE)","v":""},{"$f":"VLOOKUP(B17,Options!S:U,3,FALSE)","v":""},0,0.5,{"$f":"F17/(1-G17)","v":0},"Enter total cost for custom I/O"]
[null,null,null,null,null,null,null,null,"in green cell (boards + cables)"]
[null,"<Enter additional I/O details here. Cell will expand as needed.>"]
[]
["Your system part number:",{"$f":"_xlfn.CONCAT(D9:D17)","v":"JB-OSB"},null,null,null,75,null,150,"Assembly / test labor"]
["Your system description:",{"$f":"_xlfn.CONCAT(E9:E17)","v":"JetBox Osbourne, "},null,null,null,{"$f":"SUM(F9:F21)","v":705},null,{"$f":"SUM(H9:H21)","v":1410},"Calculated price"]
[null,null,null,null,null,"BOM cost",null,0,"Bonus"]
[null,null,null,null,null,null,null,10,"Rounding"]
[null,null,null,null,null,null,null,{"$f":"MROUND(H23+H22,H24)","v":1410},"Qty 1 price end user"]
[null,null,null,null,null,null,null,{"$f":"H25-F22","v":705},"Margin $"]
[null,null,null,null,null,null,null,{"$f":"H26/H25","v":0.5},"Margin %"]
[null,null,null,null,null,null,null,{"$f":"LEN(B22)","v":17},"Description length"]

{"sheet":"Options","index":1,"n_rows":11,"n_cols":21,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Orin Module","Module","Module","Module","Module","Module","Integrated mass storage","SSD","SSD","SSD","SSD","SSD","GMSL Cameras","GMSL","GMSL","GMSL","GMSL","GMSL","Expansion I/O","Expansion","Expansion"]
["Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","",""]
["*Orin 32GB","-32G","Orin 32GB, ",999,0.3,{"$f":"ROUND(D3/(1-E3),0)","v":1427},"*1TB M.2 2280 SSD","-1T","1TB SSD, ",92.5,0.4,{"$f":"ROUND(J3/(1-K3),0)","v":154},"*No GMSL","-G0","No GMSL",0,0.5,{"$f":"ROUND(P3/(1-Q3),0)","v":0},"*My system has no additional I/O requirements","-01",""]
["Orin 64GB","-64G","Orin 64GB, ",1799,0.3,{"$f":"ROUND(D4/(1-E4),0)","v":2570},"2TB M.2 2280 SSD","-2T","2TB SSD, ",157.9,0.4,{"$f":"ROUND(J4/(1-K4),0)","v":263},"1 GMSL","-G1","1 GMSL",325,0.5,{"$f":"ROUND(P4/(1-Q4),0)","v":650},"My system requires additional I/O (list below)","-XX (requires factory review)"," (requires factory review)"]
["Orin Industrial","-64GIT","Orin 64GB Industrial, ",2349,0.3,{"$f":"ROUND(D5/(1-E5),0)","v":3356},"512GB M.2 2280 SSD","-512G","512GB SSD, ",59.6,0.4,99,"2 GMSL","-G2","2 GMSL",350,0.5,700]
[null,null,null,null,null,null,"No additional SSD","","No SSD, ",0,0.4,0,"3 GMSL","-G3","3 GMSL",375,0.5,750]
[null,null,null,null,null,null,null,null,null,null,null,null,"4 GMSL","-G4","4 GMSL",400,0.5,800]
[null,null,null,null,null,null,null,null,null,null,null,null,"5 GMSL","-G5","5 GMSL",425,0.5,850]
[null,null,null,null,null,null,null,null,null,null,null,null,"6 GMSL","-G6","6 GMSL",450,0.5,900]
[null,null,null,null,null,null,null,null,null,null,null,null,"7 GMSL","-G7","7 GMSL",475,0.5,950]
[null,null,null,null,null,null,null,null,null,null,null,null,"8 GMSL","-G8","8 GMSL",500,0.5,1000]

{"sheet":"Instructions","index":2,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Instructions to publish customer version of this spreadsheet"]
["Select Options tab, Right click, Hide."]
["Select this tab, Right click, Hide."]
["On Web form tab, select all yellow user entry cells (ctrl+click to select all at once)."]
["Right click, Format cells."]
["Select Protection tab. Set options as shown at right. This should already be configured."]
["On Web form tab, select all columns with red Hide labels. Right click, Hide."]
["Top menu: Review, Protect Sheet. Configure options as shown. Enter password (twice)."]
["Top menu: Review, Protect Workbook. Configure options as shown. Enter password (twice)."]
["Use same standard password for everything."]
["Save file with \"(customer)\" appended to filename. Preserve all existing filename text."]
["This new customer file can be given to customers and salespeople for their use."]
["Original file should not be distributed outside the company."]